﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace EMoney.IStock.Client.DataAccess.CJ
{
    public class CJDAL
    {
        /// <summary>
        /// 查询用户所有的中奖记录
        /// </summary>
        /// <param name="userid"></param>
        /// <returns></returns>
        public DataTable select(string userid)
        {
            try
            {
                SqlParameter[] parms = { 

                                       new SqlParameter("@userid",SqlDbType.VarChar)
                                       };

                parms[0].Value = userid;

                DataTable tb = SQLHelper.ExecuteGetTable(ConnectionManager.Emfstock_ACT, CommandType.StoredProcedure, "p_act_getlog", parms);
                return tb;
            }
            catch (Exception ex)
            {
                return new DataTable();
            }
        }



    }
}
